Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$ENQUEUE_STAT

This view displays statistics on the number of enqueue (lock) requests for each type of lock.

Column | Datatype | Description
--- | --- | ---
`INST_ID` | `NUMBER` | Database instance number
`EQ_TYPE` | `VARCHAR2(2)` | Type of enqueue requested
`TOTAL_REQ#` | `NUMBER` | Total number of enqueue requests or enqueue conversions for this type of enqueue
`TOTAL_WAIT#` | `NUMBER` | Total number of times an enqueue request or conversion resulted in a wait
`SUCC_REQ#` | `NUMBER` | Number of times an enqueue request or conversion was granted
`FAILED_REQ#` | `NUMBER` | Number of times an enqueue request or conversion failed
`CUM_WAIT_TIME` | `NUMBER` | Total amount of time (in milliseconds) spent waiting for the enqueue or enqueue conversion